package com.gugee.ins.web.repository;


import com.gugee.ins.web.model.mysql.InsDicCategory;
import org.springframework.data.jdbc.repository.query.Query;
import org.springframework.data.repository.CrudRepository;

import java.util.List;

public interface InsDicCategoryRepository extends CrudRepository<InsDicCategory,Long> {

    @Query("select distinct overall_category,overall_category_cn from ins_dic_category order by overall_category ")
    List<InsDicCategory> findOverall();

    List<InsDicCategory> findByOverallCategory(String overallCategory);
}
